﻿CREATE TABLE [dbo].[ContainerLading] (
    [Id]              INT           IDENTITY (1, 1) NOT NULL,
    [IsDeleted]       BIT           NOT NULL,
    [CreatedDate]     DATETIME      NOT NULL,
    [ModifiedDate]    DATETIME      NOT NULL,
    [TaskId]          INT           NOT NULL,
    [ContainerNumber] VARCHAR (32)  NOT NULL,
    [BillNumber]      VARCHAR (32)  NULL,
    [Conveyance]      VARCHAR (32)  NULL,
    [VoyageNumber]    VARCHAR (16)  NULL,
    [Admitted]        BIT           NOT NULL,
    [Assigned]        BIT           NOT NULL,
    [LadingStatus]    NVARCHAR (32) NULL,
    [LadingComment]   NVARCHAR (64) NULL,
    [EnteredDate]     DATETIME      NULL,
    [LeftDate]        DATETIME      NULL,
    [WarningMessage]  NVARCHAR (64) NULL,
    [Dock]            NVARCHAR (16) NOT NULL
);

